package com.beauxi.adatos;

public class ConstantesAD {
	protected static final String DATABASE_NAME = "beauxi";
	protected static final String DATABASE_TABLE = "dcromos";
	protected static final int DATABASE_VERSION = 1;
	
	public static final String KEY_TITLE = "titulo";
	public static final String KEY_BODY = "descripcion";
	public static final String KEY_DATE_DOWN = "fechdescarga";
	public static final String KEY_URL_WEB = "urlweb";
	public static final String KEY_MAIL = "mail";
	public static final String KEY_NUMVECES = "numveces";
	public static final String KEY_ROWID = "_id";
	
	
	protected static final String DATABASE_CREATE =
			"create table " + DATABASE_TABLE + " ("
					+ KEY_ROWID + " integer primary key autoincrement, "
					+ KEY_TITLE + " text not null, "
					+ KEY_BODY  + " text not null, "
					+ KEY_DATE_DOWN + " text not null, "
					+ KEY_URL_WEB + " text not null, "
					+ KEY_MAIL + " text not null, " 
					+ KEY_NUMVECES + " integer not null);";
	
}
